<?php // no direct access
defined('_JEXEC') or die('Restricted access');

$canEdit	= ($this->user->authorize('com_content', 'edit', 'content', 'all') || $this->user->authorize('com_content', 'edit', 'content', 'own'));
$db = &JFactory::GetDBO();
$query2 = 'SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section,' .
					' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,'.
					' CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug,'.
					' g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access '.
					' FROM #__content AS a' .
					' LEFT JOIN #__categories AS cc ON cc.id = a.catid' .
					' LEFT JOIN #__sections AS s ON s.id = cc.section AND s.scope = "content"' .
					' LEFT JOIN #__users AS u ON u.id = a.created_by' .
					' LEFT JOIN #__groups AS g ON a.access = g.id'. 'WHERE catid=3 AND state=1';
$db->setQuery($query2);
$tmp = $db->loadObject();
//var_dump($tmp);die;
?>
  <section id="main">
                        	<!--left sidebar-->
                            <aside>
                            	<!--Category-->
                            	<div class="category" id="serviceCat">
                                    <h2>Services</h2>
                                    <ul class="cat-list">
									<?php for($i=0;i<count($row);$i++){?>
                                    	<!-- <li class="current"><a href="service_detail.html">Privat rengøring</a></li> -->
                                        <li><a href="index.php?option=com_content&view=article&id=<?php echo $row[$i]->id ?>&Itemid=21"><?php echo $row[$i]->title ?></a></li>
                                       
										<?php }?>
                                    </ul> 
                                </div>
                                <!-- /Category-->
                                <div class="contact-info">
                                     {module Firma infomation}
                                </div>
                            </aside>
                            <!-- Begin main-content  -->
                            <div class="with-sidebar" id="content">
                                <h1 class="page-title"><a href="services.html" class="parent">SERVICES</a><span class="arrow"></span><span class="current">Kontor rengøring</span></h1>
                                <!-- Begin service content  -->
                                <div class="content-ctn">
                                    <div class="article-ctn">
                                    	
                                    </div>
                                    <a href="index.php?option=com_contact&view=contact&id=1&Itemid=23" class="service-contact-btn">Læs mere om vores service - Tryk her!</a>
                                	<div class="back-ctn"><a href="javascript:history.back();" class="back">Tilbage</a></div>
                                </div>
                                <!-- / service content  -->
                                
                            </div>
                            <!-- / main-content  -->
                              
                            <!-- /end mid-content  -->
                        </section>